NotesSQL 2.05 Reference * Context sensitive Hidden document Created by Crusader. * Do not copy this document to other databases as the doclinks are specific to this database.: CN=Avshalom Neer/OU=CAM/O=Lotus CN=Michael Stewart/OU=CAM/O=Lotus FOLDER_DIRECTORY_OBJECT Favorite Topics FoA"g !UpXX ]L>7a sJ=:'g (a. Contents\b. Tell Me About... )| REF (a. Contents\b. Tell Me About... )| REF (a. Contents\c. Troubleshooting )| Mess (a. Contents\b. Tell Me About... )| REF (a. Contents\c. Troubleshooting )| Mess (a. Contents\b. Tell Me About... )| REF (a. Contents\c. Troubleshooting )| Mess (a. Contents\b. Tell Me About... )| REF (a. Contents\c. Troubleshooting )| Mess CN=Michael Stewart/OU=CAM/O=Lotus BodyWrite the body of the help document here. Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes CN=Machael Stewart/OU=CAM/O=Lotus CN=Michael Stewart/OU=CAM/O=Lotus CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Michael Stewart/OU=CAM/O=Lotus PrimeView PrimeViewAssign this document to a (main) view. a. How Do I?b. What's New?c. Top 10 Taskse. Search IndexRef a. Setting UpRef b. WorkspaceRef c. ShortcutsRef d. ScriptingRef e. @FunctionsRef f. Troubleshooting. Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes CN=Michael Stewart/OU=CAA/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes Section SectionAssign this topic to a category. 1. HOW DO I?2. GETTING STARTED3. MENUS & DIALOG BOXES4. SMARTICONS5. SCRIPTING & FORMULAS6. MESSAGES7. SHORTCUTS Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes Start_Here Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes TopicNumber Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes TopicNumber Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes Whats_New Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Devalopment/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Develapment/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Developaent/O=Lotus Notes CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes (a. Contents\b. Tell Me About... )| REF CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes (a. Contents\c. Troubleshooting )| Mess CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Stephen Auriemma/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus NotesCN=Stephen Auriemma/OU=CAM/O=LotusCN=Lotus Notes Template Aevelopment/O=Lotus Notes Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes sanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes Start_Here Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes TopicNumber Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes TopicNumber Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes Whats_New Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes 07/16/96 06:06:40 PM Susanna Doyle updated OtherDomainServers 07/16/96 06:06:37 PM Susanna Doyle updated LocalDomainServers 07/11/96 02:48:57 PM Susanna Doyle deleted cpd-qa-server 07/11/96 02:48:55 PM Susanna Doyle deleted Susanna Doyle 07/11/96 02:48:49 PM Susanna Doyle deleted RISKY 07/11/96 02:48:47 PM Susanna Doyle deleted Joe Levine 07/11/96 02:48:46 PM Susanna Doyle deleted FASTLANE 07/11/96 02:48:45 PM Susanna Doyle deleted Doc 07/11/96 02:48:43 PM Susanna Doyle deleted David Malone Privilege 1 Privilege 2 Privilege 3 Privilege 4 Privilege 5 -Default- LocalDomainServers OtherDomainServers Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes[D Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes[D CN=Michael Stewart/OU=CAM/O=Lotus####################################################### ########################################################## ########################################################## TopicNumberTopicNumber TopicNumber Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes#### BodyBody BodyWrite the body of the help document here. Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes########################################## TopicNumberTopicNumber TopicNumber Marian SternSusanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes###################### SectionSection Section SectionAssign this topic to a category. 1. HOW DO I?2. GETTING STARTED3. MENUS & DIALOG BOXES4. SMARTICONS5. SCRIPTING & FORMULAS6. MESSAGES7. SHORTCUTS Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes############################ Whats_NewWhats_New Whats_New Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes########## PrimeViewPrimeView PrimeView PrimeViewAssign this document to a (main) view. a. How Do I?b. What's New?c. Top 10 Taskse. Search IndexRef a. Setting UpRef b. WorkspaceRef c. ShortcutsRef d. ScriptingRef e. @FunctionsRef f. Troubleshooting. Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes######################## ViewSectionViewSection ViewSection ViewSectionAssign this topic to a topic group.3 Use DatabasesUse ViewsUse DocumentsSearch for InformationUse MailPrint Documents and ViewsKeep Notes SecureShare Information With Other ApplicationsUse Notes Away from a NetworkDesign Notes DatabasesManage Notes DatabasesAdminister Notes Servers---Where is this Release 3 command?What are the important new features?What changed at the last minute?How do I upgrade my site to Release 4?----Things you do before startingThings you do every dayThings you do frequentlyOther things-----About NotesSetting Up NotesStarting & Stopping NotesAbout Other Notes Documentation------About MenusAbout the SmartIcons PaletteAbout WindowsAbout FoldersAbout Split PanesAbout the Status Bar-------SmartIcon ShortcutsMouse ShortcutsKeyboard Shortcuts--------About ScriptingLotusScript BasicsLotusScript Reference----------@Functions Basics@Functions Reference@Commands Basics@Comands Reference---------About MessagesAbout Customer SupportList of Messagest Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes######################################################## Start_HereStart_Here Start_Here Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes######## CN=Michael Stewart/OU=CAM/O=Lotus################################# HHelp Topics - Printed BooktNotesSQL 2.05 Reference CN=Michael Stewart/OU=CAM/O=Lotus bfffffa bffffff ################################ CN=Michael Stewart/OU=CAM/O=Lotus######################### H_USING_NOTES_INTERNAL_FIELDSUsing Notes Internal Fields 03 Chapter 3: Using NotesSQL Fields, Notes internalInternal fields, NotesNotes internal fields Contents AboutContext Help FormUsing Notes Internal FieldsAbout CN=Michael Stewart/OU=CAM/O=Lotus ####################################################### H_HARDWARE_AND_SOFTWARE_REQUIREMENTS_OVERVIEWSoftware RequirementsOverview H_HARDWARE_AND_SOFTWARE_REQUIREMENTS_OVERVIEW_MIDTOPIC_401314073629253485=Third-Party Application SupportContext Help FormSoftware Requirements Contents 02 Chapter 2: Installation and Configuration Overview Hardware, requiredPrerequisitesRequirements, hardware and softwareSoftware, required CN=Michael Stewart/OU=CAM/O=Lotus ################################################## aMarian SternContext Help Form CN=Michael Stewart/OU=CAM/O=LotusDC PrintIndentPrint_SequencePrint2Print1Index_EntriesIndentTopicTypeDoc_NumberSectionBookViewBodySubject############################################### Reviewer ResponseC TrySubjectExpertiseTitleExtensionContactHowBodyMainCommentDateReviewerSubjectInherit CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes@ ########################################################## (Reviewer Responses)d TrySubjectReviewer$Conflict Reviewer Response L1S2S3S1& TrySubjectReviewer TrySubjectTopicReviewerReviewer Susanna DoyleCN=Lotus Notes Template Development/O=Lotus Notes ######################### $Modified 1S2S3S $TITLE$FormPrivs$FormUsers$Body$Flags$Class$Modified$Comment$AssistTrigger$AssistType$AssistFlags$UpdatedBy$$FormScript_O$LANGUAGE $Flags 0SL1S4S5S3724 $TITLE CN=Michael Stewart/OU=CAM/O=Lotus #################################### !UpXX H_NEW_FEATURES_IN_THIS_RELEASE_OVERVIEWNew Features in this Release 01 Chapter 1: About Lotus NotesSQL New features Contents OverviewContext Help FormNew Features in this ReleaseOverview CN=Michael Stewart/OU=CAM/O=Lotus ################### ########################################################## ########################################################## ########################################################## H_WHAT_IS_ODBC_OVERVIEWWhat is ODBC? 01 Chapter 1: About Lotus NotesSQL ODBCOverview Contents OverviewContext Help FormWhat is ODBC?Overview CN=Michael Stewart/OU=CAM/O=Lotus ########################################################## Marian Stern(a. Contents\b. Tell Me About... )| REF( Section Section 3S4S6S10S12S13S14S15S17S21S MainComment Reviewer" 0S0E Indent Subject Indent Subject Subject 3S4S6S10S12S13S15S16S17S19S23S25S26S28S32S34S35S Book$21Doc_Number$17$22$Conflict$REF Reference Viewt L1S5S7S8S16 Book$21Doc_Number$22Y CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes Marian Stern(a. Contents\c. Troubleshooting )| Mess Section Section 3S4S6S10S12S13S14S15S17S21S Indent Subject Indent Subject Subject 3S4S6S10S12S13S15S16S17S19S23S25S26S28S32S34S35S Book$16Doc_Number$20$Conflict$REF Troubleshooting Viewt L1S5S7S8S1+ $16Doc_Number$20 Bookh$16 Section Section 3S4S6S10S12S13S14S15S17S21SDoc_Numberh ?$20Contents: Troubleshooting Indent Subject Indent Subject Subject 3S4S6S10S12S13S15S16S17S19S23S25S26S28S32S34S35S CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ############################### $SUBVIEWMarian Sternd. Search|FIND MainComment Reviewer" 0S0E $20Subject$Conflict$REF TopicType GuideMe L1S4S5S1 Subject ?$20H MainComment Reviewer" 0S0E SubjectUse this view for full text searching& CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ########################################################## (All)@ Subject$4$Conflict$REF Subject SubjectFrame ID$4Date Last Modified HELP_WINDOW Context Help Form HELP_DOCUMENT Context Help Form formJ CN=Michael Stewart/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ################################################### ########################################################## Marian Stern(d. Printed Book)|PRINT Print1 Print1 Print2" Print2 3S4S6S10S13S14S15S17S MainComment Reviewer" 0S0E PrintIndent Subject PrintIndent Subject PrintIndent Subject Subject 3S4S6S10S12S13S15S16S17S19S23S25S26S28S29S30S32S36S38S39S45S47S48S Print1$35Print_Sequence$18$38$Conflict$REF TopicType GuideMe OnlineOnly L1S2S4S5S6S7S1< Print1$35Print_Sequence$38Y CN=Stephen Auriemma/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ###################### $$NavigatorTemplate for NHowDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ########################################################## $$NavigatorTemplate for NIdxDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes@ ########################################################## $$NavigatorTemplate for NPrintDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ########################################################## $$NavigatorTemplate for NSrchDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ########################################################## $$NavigatorTemplate for NTellDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ########################################################## $$NavigatorTemplate for NTroDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes@ ########################################################## $$NavigatorTemplate for NWIdxDC Index_EntriesTopicTypeBodySubject$$ViewBody$$NavigatorBody CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes ########################################################## $SUBVIEWMarian Stern Index_Entries Index_Entries 0S0E MainComment Reviewer" 0S0E $23$22Subject$Conflict$REF TopicType GuideMe L1S2S4S5S6S7S1 $23Subject $23IndexZ Index_Entries Index_Entries 0S0E MainComment Reviewer" 0S0E ?Subject& CN=Susanna Doyle/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus NotesCN=Stephen Auriemma/OU=CAM/O=LotusCN=Lotus Notes Template Development/O=Lotus Notes(e. Web Index) ############################ H_ADDING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEWAdding a Lotus Notes Data Source 02 Chapter 2: Installation and Configuration Data source Contents OverviewContext Help FormAdding a Lotus Notes Data SourceOverview H_ADDING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232348=To add a Lotus Notes data source: CN=Michael Stewart/OU=CAM/O=Lotus H_MODIFYING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEWModifying a Lotus Notes Data Source 02 Chapter 2: Installation and Configuration Data source Contents OverviewContext Help FormModifying a Lotus Notes Data SourceOverview H_MODIFYING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232348=To modify a Lotus Notes data source: CN=Michael Stewart/OU=CAM/O=Lotus ################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_HOW_TO_USE_THIS_BOOKHow to Use This Guide 00 Chapter 0: How to Use This Guide Documentation, about Contents AboutContext Help FormHow to Use This GuideAbout H_HOW_TO_USE_THIS_BOOK_MIDTOPIC_329696435229232314=OrganizationH_HOW_TO_USE_THIS_BOOK_MIDTOPIC_329696435229232315=Conventions Used in This Book CN=Michael Stewart/OU=CAM/O=Lotus ####################### H_UNINSTALLING_NOTESSQLUninstalling NotesSQL 02 Chapter 2: Installation and Configuration Uninstalling NotesSQL Contents AboutContext Help FormUninstalling NotesSQLAbout H_UNINSTALLING_NOTESSQL_MIDTOPIC_49641734429238162=To uninstall NotesSQL on 32-bit Windows platforms: CN=Michael Stewart/OU=CAM/O=Lotus ######################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_DELETING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEWDeleting a Lotus Notes Data Source 02 Chapter 2: Installation and Configuration Data source Contents OverviewContext Help FormDeleting a Lotus Notes Data SourceOverview H_DELETING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232348=To delete a Lotus Notes data source: CN=Michael Stewart/OU=CAM/O=Lotus H_CONNECTING_TO_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEWConnecting to a Lotus Notes Data Source 03 Chapter 3: Using NotesSQL Connection stringData sourceKeywords Contents OverviewContext Help FormConnecting to a Lotus Notes Data SourceOverview H_CONNECTING_TO_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_73957251229232354=Connection Keywords and Strings CN=Michael Stewart/OU=CAM/O=Lotus ################################### ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_MAPPING_NOTES_NAMES_TO_SQL_NAMES_OVERVIEWMapping Notes Names to SQL Names 03 Chapter 3: Using NotesSQL Notes names, mapping to SQLSQL names, mapping from Notes Contents OverviewContext Help FormMapping Notes Names to SQL NamesOverview H_MAPPING_NOTES_NAMES_TO_SQL_NAMES_OVERVIEW_MIDTOPIC_73957251229232354=Mapping CN=Michael Stewart/OU=CAM/O=Lotus ########## H_EXAMPLE_USING_SQL_TABLES_DERIVED_FROM_NOTES_FORMS_AND_VIEWS_OVERVIEWExample: Using SQL Tables Derived from Notes Forms and Views 03 Chapter 3: Using NotesSQL FormsPerformanceViews Contents OverviewContext Help FormExample: Using SQL Tables Derived from Notes Forms and ViewsOverview CN=Michael Stewart/OU=CAM/O=Lotus ################################################## H_VIEW_COLUMN_DEFINITIONS_OVERVIEWView Column Definitions 03 Chapter 3: Using NotesSQL View column definitions Contents OverviewContext Help FormView Column DefinitionsOverview CN=Michael Stewart/OU=CAM/O=Lotus ################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_ERROR_MESSAGES_OVERVIEWError Messages 03 Chapter 3: Using NotesSQL Error messages Contents OverviewContext Help FormError MessagesOverview H_ERROR_MESSAGES_OVERVIEW_MIDTOPIC_73957251229232354=Errors reported by NotesSQLH_ERROR_MESSAGES_OVERVIEW_MIDTOPIC_73957251229232355=Errors reported by Notes CN=Michael Stewart/OU=CAM/O=Lotus ########################### ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_WHAT_IS_NOTESSQL_OVERVIEWWhat is NotesSQL? 01 Chapter 1: About Lotus NotesSQL Architecture, application/driverOverviewSecurity Contents OverviewContext Help FormWhat is NotesSQL?Overview CN=Michael Stewart/OU=CAM/O=Lotus ############# H_INSTALLING_NOTESSQL_OVERVIEWInstalling NotesSQL 02 Chapter 2: Installation and Configuration Driver, adding and deletingInstallation Contents OverviewContext Help FormInstalling NotesSQLOverview H_INSTALLING_NOTESSQL_OVERVIEW_MIDTOPIC_368837628829232348=All 32-bit Windows platforms (Windows 95 or NT for Intel or Alpha)H_INSTALLING_NOTESSQL_OVERVIEW_MIDTOPIC_368837628829232349=16-bit Windows CN=Michael Stewart/OU=CAM/O=Lotus ################################################### H_DRIVER_CAPABILITIES_SQLGETINFO_RETURN_VALUESDriver Capabilities: SQLGetInfo Return Values 04 Chapter 4: Programming Capability reportingFunctionsODBCSQLGetInfo Contents AboutContext Help FormDriver Capabilities: SQLGetInfo Return ValuesAbout CN=Michael Stewart/OU=CAM/O=Lotus ######################### FoA"g H_SUMMARY_OF_SUPPORTED_ODBC_SQL_GRAMMAR_OVERVIEWSummary of Supported ODBC SQL Grammar 05 Appendix A: SQL Statements ODBCSQL, grammar supported Contents OverviewContext Help FormSummary of Supported ODBC SQL GrammarOverview H_SUMMARY_OF_SUPPORTED_ODBC_SQL_GRAMMAR_OVERVIEW_MIDTOPIC_115304224029232561=Supported StatementsH_SUMMARY_OF_SUPPORTED_ODBC_SQL_GRAMMAR_OVERVIEW_MIDTOPIC_115304224029232562=<-#>Supported Expressions, Functions, and Operators<-#> CN=Michael Stewart/OU=CAM/O=Lotus ######################################################### H_EXCEPTIONS_TO_ODBC_SQL_GRAMMAR_OVERVIEWExceptions to ODBC SQL Grammar 05 Appendix A: SQL Statements ODBCSQL, grammar supported Contents OverviewContext Help FormExceptions to ODBC SQL GrammarOverview H_EXCEPTIONS_TO_ODBC_SQL_GRAMMAR_OVERVIEW_MIDTOPIC_115304224029232561=NULL CN=Michael Stewart/OU=CAM/O=Lotus ################################################ H_SQL_TYPOGRAPHICAL_CONVENTIONS_OVERVIEWSQL Typographical Conventions 05 Appendix A: SQL Statements SQL, grammar supported Contents OverviewContext Help FormSQL Typographical ConventionsOverview H_SQL_TYPOGRAPHICAL_CONVENTIONS_OVERVIEW_MIDTOPIC_115304224029232561=<-%>Conventions<-%> CN=Michael Stewart/OU=CAM/O=Lotus ########################################### ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_COLUMN_INDEX_TABLE_AND_VIEW_NAMES_OVERVIEWColumn, Index, Table, and View Names 05 Appendix A: SQL Statements SQL, grammar supported Contents OverviewContext Help FormColumn, Index, Table, and View NamesOverview H_COLUMN_INDEX_TABLE_AND_VIEW_NAMES_OVERVIEW_MIDTOPIC_115364224029232561=Naming RulesH_COLUMN_INDEX_TABLE_AND_VIEW_NAMES_OVERVIEW_MIDTOPIC_115364224029232562=Creating Columns, Indexes, Tables, and ViewsH_COLUMN_INDEX_TABLE_AND_VIEW_NAMES_OVERVIEW_MIDTOPIC_115364224029232563=Name Visibility CN=Michael Stewart/OU=CAM/O=Lotus ########### ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_THE_UNIVERSAL_RELATION_OVERVIEWThe Universal Relation 03 Chapter 3: Using NotesSQL Universal Relation Contents OverviewContext Help FormThe Universal RelationOverview CN=Michael Stewart/OU=CAM/O=Lotus ########################################## ########################################################## ########################################################## ########################################################## ########################################################## H_MAPPING_SQL_TABLES_VIEWS_AND_INDEXES_TO_AND_FROM_NOTES_OVERVIEWMapping SQL Tables, Views, and Indexes to and from Notes 03 Chapter 3: Using NotesSQL Column namesFormsIndexesTablesViews Contents OverviewContext Help FormMapping SQL Tables, Views, and Indexes to and from NotesOverview CN=Michael Stewart/OU=CAM/O=Lotus ######################################## H_RICH_TEXT_FIELDS_OVERVIEWRich Text Fields 05 Appendix A: SQL Statements Data typesFields, rich textRich text fields Contents OverviewContext Help FormRich Text FieldsOverview CN=Michael Stewart/OU=CAM/O=Lotus ############################# H_CREATE_INDEXCREATE INDEX 05 Appendix A: SQL Statements CREATE INDEXSQL, grammar supported Contents AboutContext Help FormCREATE INDEXAbout H_CREATE_INDEX_MIDTOPIC_300828243229232709=SyntaxH_CREATE_INDEX_MIDTOPIC_300828243229232710=ExampleH_CREATE_INDEX_MIDTOPIC_300828243229232711=ArgumentsH_CREATE_INDEX_MIDTOPIC_300828243229232712=Restrictions CN=Michael Stewart/OU=CAM/O=Lotus ############################## H_CREATE_TABLE_OVERVIEWCREATE TABLE 05 Appendix A: SQL Statements CREATE TABLESQL, grammar supported Contents OverviewContext Help FormCREATE TABLEOverview H_CREATE_TABLE_OVERVIEW_MIDTOPIC_115414224029232561=SyntaxH_CREATE_TABLE_OVERVIEW_MIDTOPIC_115414224029232562=ExampleH_CREATE_TABLE_OVERVIEW_MIDTOPIC_115414224029232563=ArgumentsH_CREATE_TABLE_OVERVIEW_MIDTOPIC_115414224029232564=Restrictions CN=Michael Stewart/OU=CAM/O=Lotus ########################################### H_CREATE_VIEW_OVERVIEWCREATE VIEW 05 Appendix A: SQL Statements CREATE VIEWSQL, grammar supported Contents OverviewContext Help FormCREATE VIEWOverview H_CREATE_VIEW_OVERVIEW_MIDTOPIC_115304224029232561=SyntaxH_CREATE_VIEW_OVERVIEW_MIDTOPIC_115304224029232562=ExampleH_CREATE_VIEW_OVERVIEW_MIDTOPIC_115304224029232563=Arguments CN=Michael Stewart/OU=CAM/O=Lotus #################################################### ########################################################## ########################################################## ########################################################## H_USING_THE_UNIVERSAL_RELATION_OVERVIEWUsing the Universal Relation 03 Chapter 3: Using NotesSQL Universal Relation Contents OverviewContext Help FormUsing the Universal RelationOverview CN=Michael Stewart/OU=CAM/O=Lotus ######################## H_USING_SQL_TABLES_DERIVED_FROM_NOTES_FORMS_AND_VIEWS_OVERVIEWUsing SQL Tables Derived from Notes Forms and Views 03 Chapter 3: Using NotesSQL FormsIndexesPerformanceTablesViews Contents OverviewContext Help FormUsing SQL Tables Derived from Notes Forms and ViewsOverview CN=Michael Stewart/OU=CAM/O=Lotus ###################################################### H_DELETE_POSITIONED_OVERVIEWDELETE Positioned 05 Appendix A: SQL Statements DELETE PositionedSQL, grammar supported Contents OverviewContext Help FormDELETE PositionedOverview H_DELETE_POSITIONED_OVERVIEW_MIDTOPIC_115364224029232561=SyntaxH_DELETE_POSITIONED_OVERVIEW_MIDTOPIC_115364224029232562=ExampleH_DELETE_POSITIONED_OVERVIEW_MIDTOPIC_115364224029232563=Arguments CN=Michael Stewart/OU=CAM/O=Lotus ########## H_DELETE_SEARCHED_OVERVIEWDELETE Searched 05 Appendix A: SQL Statements DELETE SearchedSQL, grammar supported Contents OverviewContext Help FormDELETE SearchedOverview H_DELETE_SEARCHED_OVERVIEW_MIDTOPIC_115364224029232561=SyntaxH_DELETE_SEARCHED_OVERVIEW_MIDTOPIC_115364224029232562=ExampleH_DELETE_SEARCHED_OVERVIEW_MIDTOPIC_115364224029232563=Arguments CN=Michael Stewart/OU=CAM/O=Lotus ####################### ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_USING_NOTES_VIEWS_AS_INDEXES_OVERVIEWUsing Notes Views as Indexes 03 Chapter 3: Using NotesSQL IndexesNotes viewsViews Contents OverviewContext Help FormUsing Notes Views as IndexesOverview H_USING_NOTES_VIEWS_AS_INDEXES_OVERVIEW_MIDTOPIC_73957251229232354=Unique Indexes CN=Michael Stewart/OU=CAM/O=Lotus ############################################# H_DROP_VIEW_OVERVIEWDROP VIEW 05 Appendix A: SQL Statements DROP VIEWSQL, grammar supported Contents OverviewContext Help FormDROP VIEWOverview H_DROP_VIEW_OVERVIEW_MIDTOPIC_115364224029232561=Syntax H_DROP_VIEW_OVERVIEW_MIDTOPIC_115364224029232562=ExampleH_DROP_VIEW_OVERVIEW_MIDTOPIC_115364224029232563=ArgumentsH_DROP_VIEW_OVERVIEW_MIDTOPIC_115364224029232564=Restrictions: CN=Michael Stewart/OU=CAM/O=Lotus H_INSERT_OVERVIEWINSERT 05 Appendix A: SQL Statements INSERTSQL, grammar supported Contents OverviewContext Help FormINSERTOverview H_INSERT_OVERVIEW_MIDTOPIC_115364224029232561=SyntaxH_INSERT_OVERVIEW_MIDTOPIC_115364224029232562=ExamplesH_INSERT_OVERVIEW_MIDTOPIC_115364224029232563=ArgumentsH_INSERT_OVERVIEW_MIDTOPIC_115364224029232564=Notes Field Events CN=Michael Stewart/OU=CAM/O=Lotus #################### H_SELECT_OVERVIEWSELECT 05 Appendix A: SQL Statements SELECTSQL, grammar supported Contents OverviewContext Help FormSELECTOverview H_SELECT_OVERVIEW_MIDTOPIC_115304224029232561=SyntaxH_SELECT_OVERVIEW_MIDTOPIC_115304224029232562=Arguments CN=Michael Stewart/OU=CAM/O=Lotus ############## H_TIPS_FOR_THIRDPARTY_APPLICATIONS_AND_CAVEATS_OVERVIEWTips for Third-Party Applications and Caveats 03 Chapter 3: Using NotesSQL Applications, tipsTips, applications Contents OverviewContext Help FormTips for Third-Party Applications and CaveatsOverview H_TIPS_FOR_THIRDPARTY_APPLICATIONS_AND_CAVEATS_OVERVIEW_MIDTOPIC_73957251229232354=These are known limitations or problems with NotesSQL: CN=Michael Stewart/OU=CAM/O=Lotus ######################################################## ]L>7a H_NUMERIC_OPERATORS_OVERVIEWNumeric Operators 05 Appendix A: SQL Statements Numeric operatorsOperators, numericSQL, grammar supported Contents OverviewContext Help FormNumeric OperatorsOverview CN=Michael Stewart/OU=CAM/O=Lotus ############ ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_MULTIVALUED_FIELDS_LIST_FIELDS_OVERVIEWMulti-Valued Fields (List Fields) 05 Appendix A: SQL Statements Data typesList fieldsMulti-valued fields Contents OverviewContext Help FormMulti-Valued Fields (List Fields)Overview H_MULTIVALUED_FIELDS_LIST_FIELDS_OVERVIEW_MIDTOPIC_115364224029232561=Text Form FieldsH_MULTIVALUED_FIELDS_LIST_FIELDS_OVERVIEW_MIDTOPIC_115364224029232562=Numeric and Date Form FieldsH_MULTIVALUED_FIELDS_LIST_FIELDS_OVERVIEW_MIDTOPIC_78295372829252458=Display separator characters in view columns CN=Michael Stewart/OU=CAM/O=Lotus ####################################################### H_HAVING_OVERVIEWHAVING 05 Appendix A: SQL Statements HAVINGSQL, grammar supported Contents OverviewContext Help FormHAVINGOverview H_HAVING_OVERVIEW_MIDTOPIC_183107062429232357=SyntaxH_HAVING_OVERVIEW_MIDTOPIC_183157062429232358=Example CN=Michael Stewart/OU=CAM/O=Lotus ################ H_ORDER_BY_OVERVIEWORDER BY 05 Appendix A: SQL Statements ORDER BYSQL, grammar supported Contents OverviewContext Help FormORDER BYOverview H_ORDER_BY_OVERVIEW_MIDTOPIC_115414224029232561=SyntaxH_ORDER_BY_OVERVIEW_MIDTOPIC_115414224029232562=Example CN=Michael Stewart/OU=CAM/O=Lotus H_UNION_OVERVIEWUNION 05 Appendix A: SQL Statements SQL, grammar supportedUNION Contents OverviewContext Help FormUNIONOverview H_UNION_OVERVIEW_MIDTOPIC_115364224029232561=SyntaxH_UNION_OVERVIEW_MIDTOPIC_115364224029232562=Example CN=Michael Stewart/OU=CAM/O=Lotus ###################### H_WHERE_OVERVIEWWHERE 05 Appendix A: SQL Statements SQL, grammar supportedWHERE Contents OverviewContext Help FormWHEREOverview H_WHERE_OVERVIEW_MIDTOPIC_115304224029232561=SyntaxH_WHERE_OVERVIEW_MIDTOPIC_115304224029232562=ExamplesH_WHERE_OVERVIEW_MIDTOPIC_115304224029232563=Arguments CN=Michael Stewart/OU=CAM/O=Lotus ############################# H_PREDICATE_OPERATORS_OVERVIEWPredicate Operators 05 Appendix A: SQL Statements Operators, predicatePredicate operatorsSQL, grammar supported Contents OverviewContext Help FormPredicate OperatorsOverview CN=Michael Stewart/OU=CAM/O=Lotus H_DATA_TYPES_OVERVIEWData Types 03 Chapter 3: Using NotesSQL Data typesList fieldsRich text fields Contents OverviewContext Help FormData TypesOverview H_DATA_TYPES_OVERVIEW_MIDTOPIC_73957251229232354=ODBC SQL to Notes data type mapping:H_DATA_TYPES_OVERVIEW_MIDTOPIC_73957251229232355=Notes to SQL data type mapping: CN=Michael Stewart/OU=CAM/O=Lotus ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_ODBC_API_FUNCTIONSODBC API Functions 04 Chapter 4: Programming ODBCProgrammingSQLCancelSQLColumnPrivilegesSQLColumnsSQLForeignKeysSQLGetConnectOptionSQLGetStmtOptionSQLPrimaryKeysSQLProcedureColumnsSQLProceduresSQLSetConnectOptionSQLSetParamSQLSetScrollOptionsSQLSetStmtOptionSQLTablePrivilegesSQLTablesSQLTransact Contents AboutContext Help FormODBC API FunctionsAbout H_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232708=SQLCancelH_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232709=SQLColumnsH_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232710=SQLGetConnectOption<**>SQLSetConnectOptionH_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232711=SQLGetStmtOption<**>SQLSetStmtOptionH_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232712=SQLSetParam<**>SQLSetScrollOptionsH_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232713=SQLTablesH_ODBC_API_FUNCTIONS_MIDTOPIC_381924972829232714=SQLTransact CN=Michael Stewart/OU=CAM/O=Lotus ################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_ALTER_TABLE_OVERVIEWALTER TABLE 05 Appendix A: SQL Statements ALTER TABLESQL, grammar supported Contents OverviewContext Help FormALTER TABLEOverview H_ALTER_TABLE_OVERVIEW_MIDTOPIC_115304224029232561=Syntax H_ALTER_TABLE_OVERVIEW_MIDTOPIC_115304224029232562=ExampleH_ALTER_TABLE_OVERVIEW_MIDTOPIC_115304224029232563=ArgumentsH_ALTER_TABLE_OVERVIEW_MIDTOPIC_115304224029232564=Restrictions CN=Michael Stewart/OU=CAM/O=Lotus ################################################## H_DROP_INDEXDROP INDEX 05 Appendix A: SQL Statements DROP INDEXSQL, grammar supported Contents AboutContext Help FormDROP INDEXAbout H_DROP_INDEX_MIDTOPIC_115304224029232561=SyntaxH_DROP_INDEX_MIDTOPIC_115304224029232562=ExampleH_DROP_INDEX_MIDTOPIC_115304224029232563=Arguments CN=Michael Stewart/OU=CAM/O=Lotus ##################################### H_DROP_TABLE_OVERVIEWDROP TABLE 05 Appendix A: SQL Statements DROP TABLESQL, grammar supported Contents OverviewContext Help FormDROP TABLEOverview H_DROP_TABLE_OVERVIEW_MIDTOPIC_115364224029232561=Syntax H_DROP_TABLE_OVERVIEW_MIDTOPIC_115364224029232562=Example H_DROP_TABLE_OVERVIEW_MIDTOPIC_115364224029232563=Arguments CN=Michael Stewart/OU=CAM/O=Lotus ######################################################### ########################################################## Favorite TopicsFavorite Topics CN=Michael Stewart/OU=CAM/O=Lotus: Subject$Conflict$REF L1S1 Subject ?SubjectFrequently useful topics& ############################################## ########################################################## ########################################################## ########################################################## ########################################################## ########################################################## H_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEWConfiguring a Lotus Notes Data Source 02 Chapter 2: Installation and Configuration Data sourceDatabase connection parametersInstallationSQL statement length Contents OverviewContext Help FormConfiguring a Lotus Notes Data SourceOverview H_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232348=Data Source Name *H_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232349=DescriptionH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232350=Server *H_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232351=Database *H_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232352=Max Length of Text FieldsH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232353=Max Number of TablesH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232354=Max Number of SubqueriesH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232355=Keep Temporary Indexes until SQLDisconnectH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232356=Return Notes Implicit FieldsH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232357=Map Special CharactersH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232358=Max Length of Rich Text FieldsH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232359=SQL Statement LengthH_CONFIGURING_A_LOTUS_NOTES_DATA_SOURCE_OVERVIEW_MIDTOPIC_368837628829232360=Thread Timeout (available on 32-bit Windows platforms only) CN=Michael Stewart/OU=CAM/O=Lotus ################################# ########################################################## ########################################################## ########################################################## O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO $ACLDigest O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO $ACLDigest O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO $INFO $BODY O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO O+n25 $INFO $BODY O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO Ko{uI $INFO $BODY O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO $INFO $BODY O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO $INFO $BODY O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO $INFO $BODY O=Lotus Notes O=Lotus Notes PURSAFO |.:#U O=Lotus Notes CN=Lotus Notes Template Development/O=Lotus Notes PURSAFO Ei